﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MandalaySoft.Common;
using System.Data;

namespace SIMS.BL.Common
{
    public class Listing
    {
        MyDatabase _db;
        MyError _error;
        public DataTable GetLanguageInfoList()
        {
            _db = new MyDatabase();
            _error = new MyError();
            DataTable _dtRet = new DataTable("tblRet");
            _dtRet = _db.GetDataTable("sprocLanguageInfoSelectList", CommandType.StoredProcedure, new System.Collections.SortedList(), out _error);
            return _dtRet;
        }

        public DataTable GetUserProfileList()
        {
            _db = new MyDatabase();
            _error = new MyError();
            DataTable _dtRet = new DataTable("tblRet");
            _dtRet = _db.GetDataTable("sprocUserProfileSelectList", CommandType.StoredProcedure, new System.Collections.SortedList(), out _error);
            return _dtRet;
        }

        public Listing()
        {

        }
    }
}
